Table widget
Configuring Table widget
To configure Table widget do the following:
-
From the right side of the widget generation page, click the Update Widget Column Configurations icon.
-
Configure any of the following:
Items Description Visible columns Drag the items to reorder the columns in the table. Click any of the values to: - Change the title of the value column.
- Specify the sorting order: Ascending or Descending.
- Utilize Top/Bottom analysis to pinpoint the highest (Top) or lowest (Bottom) performers within a dataset based on a chosen metric, displaying a specified number (N) of these entities for focused insights. You can set the direction (top or bottom) and provide the number limit.
- Choose an option from the Numeric Notions to select how numerical values are displayed:
- Auto: The system automatically determines the most appropriate notation (standard, thousands, millions) based on the magnitude of the data.
- Thousands (K): Displays values in thousands, abbreviated with K (e.g., 10,000 becomes 10K).
- Millions (M): Displays values in millions, abbreviated with M (e.g., 1,000,000 becomes 1M).
- In Decimal, specify the number of digits to display after the decimal point.
- Conditional format the columns and create rules for the same. Refer to Conditional formatting for tables and Pivot tables.
Not Visualized Lists the selected columns that are not yet visualized in the canvas.
Setting Table widget
To set the Table widget, do the following:
-
From the right side of the widget generation page, click the Update settings icon.
-
Set the following:
Item Description General Set general details. Title Edit the title of the chart. Subtitle Edit the subtitle of the chart. Help message Type the message that appears when you hover over the help icon. Display Set the display details of the table. Density Specify the density of each row. The following options are available: Short, Medium, Tall, and Extra Tall. Normal/Zebra Row Choose whether to maintain normal rows or Zebra rows in a table, which are alternating shades of color applied to the rows. Linked reports Set the details of the dashboard reports you want to view from this widget. Linked report URL Paste the URL of the dashboard that you want to view from this widget. Open in New tab Specify if you want to view the linked report in a different tab.